<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>About using conditional formatting in documents</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
p.whs2 { margin-left:24px; }
table.whs3 { x-cell-content-align:top; margin-left:40px; border-spacing:0px; }
tr.whs4 { x-cell-content-align:top; }
td.whs5 { border-left-width:1px; border-left-color:#000000; border-left-style:Solid; border-top-style:Solid; border-top-color:#000000; border-top-width:1px; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
p.whs6 { font-weight:bold; }
td.whs7 { border-top-style:Solid; border-top-color:#000000; border-top-width:1px; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
td.whs8 { border-left-width:1px; border-left-color:#000000; border-left-style:Solid; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
td.whs9 { border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nCreating and formatting a document\nUsing conditional formatting on documents: Thresholds\nAbout using conditional formatting in documents");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>About using conditional formatting in documents</h1>
<p>Conditional formatting allows you to format specified controls in your 
 document depending on predefined criteria. These criteria are attribute 
 or metric qualifications. Conditional formatting allows certain properties 
 of controls, including sections, to be controlled by data-driven conditions. 
 This provides the flexibility to personalize documents based on the data 
 returned by the dataset reports. Conditional formatting in documents is 
 similar to 
<a HREF="Thresholds.htm">thresholds</a> in reports.</p>
<p><span style="font-weight: bold;"><B>Note</B></span>: Derived metrics and summary 
 metrics can be used to create conditional formatting; calculated expressions 
 cannot.</p>
<p>Certain controls on your document can assume special significance (such 
 as Sales &gt; 1000, or Date of Sale prior to December 1, 2003). Conditional 
 formatting allows you to draw immediate attention to such data based on 
 the result of some expression evaluations. If an expression evaluates 
 to TRUE, the control can be: </p>
<ul type="disc" class="whs1">
	
<li class=p><p>Hidden</p></li>
	
<li class=p><p>Formatted in a particular way, for example, bold red 
 font for Sales below $1000</p></li>
	
<li class=p><p>Replaced by text, such as East for regions in the eastern 
 US</p></li>
	
<li class=p><p>Replaced by a symbol, such as a diamond for sales above 
 $100,000</p></li>
</ul>
<p class="whs2"><span style="font-weight: bold;"><B>Note</B></span>: 
 The replacement text and symbols can also be formatted.</p>
<p>Conditional formatting allows you to alert document recipients to data 
 that is likely to be important for making business decisions.</p>
<p>A conditional format is the combination of an object, a condition, and 
 formatting properties which are applied to the object when the condition 
 is met. Objects of all control types except Grid/Graph can use conditional 
 formatting. The following table lists the control types and the types 
 of conditional formatting available for each.</p>
<table x-use-null-cells cellspacing="0" class="whs3">
<script language='JavaScript'><!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4)) document.write("</table><table x-use-null-cells cellspacing='0' border='1' bordercolor='black' bordercolorlight='black' bordercolordark='black'>");
//--></script>
<col>
<col>


<tr valign="top" class="whs4">
<td class="whs5">
<p class="whs6">Control Type</td>
<td class="whs7">
<p class="whs6">Conditional Formatting Available</td></tr>

<tr valign="top" class="whs4">
<td class="whs8">
<p>Image</td>
<td class="whs9">
<ul type="disc" class="whs1">
	
<li class=p><p>Hide object</p></li>
	
<li class=p><p>Formatting: Borders</p></li>
</ul></td></tr>

<tr valign="top" class="whs4">
<td class="whs8">
<p>Line</td>
<td class="whs9">
<ul type="disc" class="whs1">
	
<li class=p><p>Hide object</p></li>
	
<li class=p><p>Formatting: Line style, color, and weight</p></li>
</ul></td></tr>

<tr valign="top" class="whs4">
<td class="whs8">
<p>Rectangle</td>
<td class="whs9">
<ul type="disc" class="whs1">
	
<li class=p><p>Hide object</p></li>
	
<li class=p><p>Formatting: Background color; line style, color, and 
 weight</p></li>
</ul></td></tr>

<tr valign="top" class="whs4">
<td class="whs8">
<p>Text field</td>
<td class="whs9">
<ul type="disc" class="whs1">
	
<li class=p><p>Hide object</p></li>
	
<li class=p><p>Replacement text and symbols</p></li>
	
<li class=p><p>Formatting: All formatting properties</p></li>
</ul></td></tr>

<tr valign="top" class="whs4">
<td class="whs8">
<p>Section</td>
<td class="whs9">
<ul type="disc" class="whs1">
	
<li class=p><p>Hide object</p></li>
	
<li class=p><p>Formatting: Background color</p></li>
</ul></td></tr>
<script language='JavaScript'><!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4)) document.write("</table></table><table>");
//--></script>
</table>
<p>For steps to apply conditional formatting quickly using simple thresholds, 
 see 
<a HREF="Cond_formatting_docs_single_metric.htm">Applying conditional 
 formatting to documents using simple thresholds</a>.</p>
<p>For steps to apply formatting to more complex threshold conditions, 
 see 
<a HREF="Cond_format_docs_multiple_metrics.htm">Applying conditional 
 formatting to documents using advanced thresholds</a>.</p>
<p class="whs6">Related topics</p>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Enable_conditional_formats.htm">Displaying 
 or hiding conditional formatting</a>.</p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
